orcli import json

import JSON

Usage

Arguments

FILE Path to one or more files or URLs. When FILE is -, read standard input. (repeatable)

Options

--recordPath JSON		`specify record path elements in JSON array`
--rename		`rename columns after import to remove record path fragments`
--guessCellValueTypes		`attempt to parse cell text into numbers`
--includeFileSources		`add column with file source`
--includeArchiveFileName		`add column with archive file name`
--limit LIMIT		`load at most x row(s) of data`
--storeEmptyStrings		`preserve empty strings`
--trimStrings		`trim leading & trailing whitespace from strings`
--projectName PROJECTNAME		`set a name for the OpenRefine project`
--projectTags PROJECTTAGS		`set project tags (comma separated)`
--quiet, -q		`suppress log output, print errors only`

Parent Environment Variables

OPENREFINE_URL URL to OpenRefine server

Examples

orcli import json "file"

orcli import json "file1" "file2"

orcli import json "https://example.com/file.json"

orcli import json "file" \
  --recordPath '[ "_", "rows", "_" ]' \
  --rename \
  --storeEmptyStrings \
  --trimStrings \
  --projectName "duplicates" \
  --projectTags "test,urgent"